Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# COPYDFN

The COPYDFN command defines a new object in the analytical workspace and uses the same definition as a specified object in the current workspace or in an attached workspace.

COPYDFN copies the DEFINE, LD, and PROPERTY lines for any type of object, and it copies the formula (EQ) of a formula object, and the value name format (VNF) of a dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR. COPYDFN also copies the text of a program or model. COPYDFN does not copy the PERMIT lines for any object, and it does not copy the compiled code of a formula, program, or model.

Syntax

COPYDFN newobject oldobject

Arguments

newobject

  The name of the new object to define.

oldobject

  The name of the object whose definition you want to copy.

Examples

Example 9-25 Copying Programs

The following statements use COPYDFN to create a new program, called `newprog`, which is a copy of an existing one called `oldprog`. You could then edit `newprog` to create a slightly different program. The `oldprog` program has the following definition.

    DEFINE oldprog PROGRAM
    LD Shows total sales for the top five months from high to low
    PROGRAM
    LIMIT district TO 'BOSTON'
    LIMIT month TO TOP 5 BASEDON TOTAL(sales, month)
    REPORT TOTAL(sales, month)
    END

The statements

    COPYDFN newprog oldprog
    DESCRIBE newprog

produce the following definition for `newprog`.

    DEFINE newprog PROGRAM
    LD Shows total sales for the top five months from high to low
    PROGRAM
    LIMIT district TO 'BOSTON'
    LIMIT month TO TOP 5 BASEDON TOTAL(sales, month)
    REPORT TOTAL(sales, month)
    END